Release 10.1A: OpenEdge Data Management:
SQL Reference

Supported Progress 4GL data types and corresponding OpenEdge SQL
data types

OpenEdge SQL supports many data types that do not correspond to Progress 4GL data types. Table 44 lists the Progress data types that do correspond to OpenEdge SQL data types.

Table 44: Progress 4GL and corresponding OpenEdge SQL data types

Progress 4GL data type	OpenEdge SQL data type
ARRAY	VARARRAY
BLOB	BLOB
CHARACTER	VARCHAR
CLOB	CLOB
DATE	DATE
DATETIME	TIMESTAMP
DATETIME-TZ	TIMESTAMP WITH TIME ZONE
DECIMAL	DECIMAL or NUMERIC
INTEGER	INTEGER
LOGICAL	BIT
RAW	VARBINARY
RECID	RECID

Notes

All other SQL types are not compatible with 4GL. In particular, OpenEdge SQL CHARACTER data is not compatible with the 4GL. Use OpenEdge SQL type VARCHAR to map 4GL CHARACTER data.
Data columns created using OpenEdge SQL that have a data type not supported by Progress 4GL are not accessible through Progress 4GL applications and utilities.
For more information about OpenEdge SQL data types, see the "OpenEdge SQL Language Elements" section,